How to calculate compound interest for an intra-year period in Excel Microsoft Excel includes the EFFECT function in the Analysis ToolPak add-in for versions older than 2003. ... The formula to calculate intra-year compound interest with the EFFECT ... Microsoft Security Essentials manual update download.